Cannot change the default chart format due to no password.
Cause:
This problem occurs because the file XL5GALRY.XLS is saved with password. This file contains user-defined formats that can be used as the default chart format and the correct password must be entered to use the formats.
Solution:
Type the correct password(s) when prompted or remove all passwords from XL5GALRY.XLS.
To remove all passwords:
1) Open the file XL5GALRY.XLS located in the XLSTART folder:
a) Select the 'File' menu and select 'Open...'. (The Open dialog box appears.)
b) Locate and open the XLSTART folder.
c) Select the file.
d) Click 'Open'. (A dialog box appears prompting for a password.)
e) e) If the protection password was set:
1] Type the protection password in the 'Password' box.
2] Click 'OK'.
f) If the write-reservation password was set:
1] Type the write-reservation password in the 'Password' box.
2] Click 'OK'. (The file opens.)
2) Select the 'File' menu and select 'Save As...'. (The Save As dialog box appears.)
3) Click 'Options...'. (The Save Options dialog box appears.)
4) Delete all the passwords in the 'File Sharing' group.
a) Delete the password, if any, in the 'Protection Password' box.
b) Delete the password, if any, in the 'Write Reservation Password' box.
5) Click 'OK'. (The Save As dialog box reappears.)
6) Locate and open the XLSTART folder.
7) Type the same filename in the 'File name' drop-down list box.
8) Click 'Save' tosave the changes.
9) Select the 'File' menu and select 'Close' to close the file.